ROUNDSIG
Rounds a number to a specified number of significant figures.
Syntax
ROUNDSIG(number, num_digits)
number - is the number you want to round.
num_digits - specifies the number of significant figures to which you want to round number.
Remark
Examples
ROUNDSIG(149.149, 1) equals 100
ROUNDSIG(149.149, 2) equals 150
ROUNDSIG(149.149, 3) equals 149
ROUNDSIG(149.149, 4) equals 149.1
ROUNDSIG(149.149, 5) equals 149.15
ROUNDSIG(149.149, 6) equals 149.149
[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]